﻿CREATE TABLE [dbo].[RefundLogs] (
    [Id]              INT            IDENTITY (1, 1) NOT NULL,
    [OrderNo]         NVARCHAR (50)  NOT NULL,
    [OrderFee]        INT            NULL,
    [RefundNo]        NVARCHAR (50)  NULL,
    [WxTransactionId] NVARCHAR (50)  NULL,
    [WxRefundId]      NVARCHAR (50)  NULL,
    [CreateTime]      DATETIME       NULL,
    [RefundStatus]    INT            NOT NULL,
    [RefundChannel]   NVARCHAR (50)  NULL,
    [RefundFee]       INT            NULL,
    [RefundReason]    NVARCHAR (50)  NULL,
    [RecieveUserId]   NVARCHAR (50)  NULL,
    [RecieveOpenId]   NVARCHAR (50)  NULL,
    [RecieveUserName] NVARCHAR (50)  NULL,
    [Remark]          NVARCHAR (200) NULL,
    CONSTRAINT [PK_RefundLogs] PRIMARY KEY CLUSTERED ([Id] ASC)
);

